Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
SaleReturnModificationSequenceNumber (PK) | The sequence number for this SaleReturnInstruction allowing more than instruction to be attached to each retail transaction line item. | AI_MDFN | LineNumber | smallint | |
AdjustmentCode | A mnemonic code denoting what kind of adjustment is being made to the Item being sold. e.g. Add, Remove, Alter,List Components | CD_ADJT | Code2 | char(2) | |
UnitOfMeasureCode (FK) | The code used to specify the units which apply to the Quantity attribute. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
ModificationQuantity | The number of Item's being added or withheld from the AggregateItem being sold. | QU_MDFN | Quantity | DECIMAL(9,3) | |
ItemID (FK) | A unique system assigned identifier for the Item that is being removed from the AggregateItem being sold. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
AdjustmentDescription | A narrative describing the required modification. e.g. Hold the Pickle, Cuffs on Trousers etc... | DE_ADJT | DescriptionNarrative | varchar(4000) | |